Access Denied

------=_NextPart_000_0001_01CA0FCB.0FBA0F30
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0002_01CA0FCB.0FBA3640"


------=_NextPart_001_0002_01CA0FCB.0FBA3640
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit



Line in Program:

//connect to server and select database

//connect to server and select database

$mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");



//create and issue the query

$sql = "SELECT f_name, l_name FROM auth_users WHERE username =
'".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";

$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));





Record in mySQl database:
Users PASSWORD

id f_name l_name email username password
ry_key=+%60auth_users%60.%60id%60+%3D+1&sql_query=SELECT+%2A +FROM+%60auth_us
ers%60&goto=sql.php&token=2e38a21d8832de9283320672387b55c7> Edit
LETE+FROM+%60testDB%60.%60auth_users%60+WHERE+%60auth_users% 60.%60id%60+%3D+
1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3F db%3DtestDB%26ta
ble%3Dauth_users%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560 auth_users%2560%
26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_ structure.php%26
token%3D2e38a21d8832de9283320672387b55c7&token=2e38a21d8832d e9283320672387b5
5c7> Delete1 John Doe john@doe.com jdoe
*0AAD744979343D58A7F17A50E514E6AD6533D04B





Message from Firefox Browser:

Warning: mysqli_connect() [function.mysqli-connect
]: (28000/1045):
Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13



This one has got me.

Please Help.



...../Ernie


------=_NextPart_001_0002_01CA0FCB.0FBA3640
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">



charset=3Dus-ascii">






lang=3DEN-CA
link=3D"#996600" vlink=3D"#666666">
v:src=3D"cid:image001.jpg@01CA0FC8.1577F7A0" v:shapes=3D"_x0000_Mail" =
width=3D0
height=3D0 class=3Dshape style=3D'display:none;width:0;height:0'>

Re: Access Denied

Ernie Kemp wrote:
>
>
> Line in Program:
>
> //connect to server and select database
>
> //connect to server and select database
>
> $mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");
>
>
>
> //create and issue the query
>
> $sql = "SELECT f_name, l_name FROM auth_users WHERE username =
> '".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";
>
> $result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));
>
>
>
>
>
> Record in mySQl database:
> Users PASSWORD
>
> id f_name l_name email username password
> > ry_key=+%60auth_users%60.%60id%60+%3D+1&sql_query=SELECT+%2A +FROM+%60auth_us
> ers%60&goto=sql.php&token=2e38a21d8832de9283320672387b55c7> Edit
> > LETE+FROM+%60testDB%60.%60auth_users%60+WHERE+%60auth_users% 60.%60id%60+%3D+
> 1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3F db%3DtestDB%26ta
> ble%3Dauth_users%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560 auth_users%2560%
> 26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_ structure.php%26
> token%3D2e38a21d8832de9283320672387b55c7&token=2e38a21d8832d e9283320672387b5
> 5c7> Delete1 John Doe john@doe.com jdoe
> *0AAD744979343D58A7F17A50E514E6AD6533D04B
>
>
>
>
>
> Message from Firefox Browser:
>
> Warning: mysqli_connect() [function.mysqli-connect
> ]: (28000/1045):
> Access denied for user 'jdoe'@'localhost' (using password: YES) in
> C:\wamp\www\rogers\userlogin.php on line 9
>

Ok, not to be harsh, but I thought I would point it out before others jumped on this one.

The answer to your question is in the question itself.

Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9

So, since line 9 is your mysqli_connect() call, I would suggest looking at the manual page for that.

http://php.net/mysqli_connect

Plus look at mysql documentation on how to create a new user, grant them privileges, and flush the
privileges table.

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

A simple Google search would have brought you to these pages.

As for the reset of the errors. Fix the first one and the others might be fixed also.

Jim

> Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in
> C:\wamp\www\rogers\userlogin.php on line 13
>
> Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in
> C:\wamp\www\rogers\userlogin.php on line 13
>
>
>
> This one has got me.
>
> Please Help.
>
>
>
> ..../Ernie
>
>


--
Jim Lucas

"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Access Denied

------=_NextPart_000_000D_01CA0FCD.AD46A180
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Please ignore.



Newbie error.... solved

Thanks



From: Ernie Kemp [mailto:ernie.kemp@sympatico.ca]
Sent: July-28-09 9:34 PM
To: php-general@lists.php.net
Subject: [PHP] Access Denied



Line in Program:

//connect to server and select database

//connect to server and select database

$mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");



//create and issue the query

$sql = "SELECT f_name, l_name FROM auth_users WHERE username =
'".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";

$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));





Record in mySQl database:
Users PASSWORD

id f_name l_name email username password
ry_key=+%60auth_users%60.%60id%60+%3D+1&sql_query=SELECT+%2A +FROM+%60auth_us
ers%60&goto=sql.php&token=2e38a21d8832de9283320672387b55c7> Edit
LETE+FROM+%60testDB%60.%60auth_users%60+WHERE+%60auth_users% 60.%60id%60+%3D+
1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3F db%3DtestDB%26ta
ble%3Dauth_users%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560 auth_users%2560%
26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_ structure.php%26
token%3D2e38a21d8832de9283320672387b55c7&token=2e38a21d8832d e9283320672387b5
5c7> Delete1 John Doe john@doe.com jdoe
*0AAD744979343D58A7F17A50E514E6AD6533D04B





Message from Firefox Browser:

Warning: mysqli_connect() [function.mysqli-connect
]: (28000/1045):
Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13



This one has got me.

Please Help.



...../Ernie


------=_NextPart_000_000D_01CA0FCD.AD46A180--